***************************************************************************************
*** DATA AND REPLICATION FILES FOR:				                                    ***
*** COSTS OF SEGREGATION: EVIDENCE FROM THE FEDERAL GOVERNMENT UNDER WOODROW WILSON ***
***************************************************************************************

The replication package contains the following do-files to reproduce the tables and figures:

table1.do
table2.do
table3.do
table4.do (*)
table5.do (*)

figure1.do
figure2.do
figure3.do
figure4.do
figure5.do
figure6.do
figure7.do (*)

The analysis was conducted with Stata 15

PLEASE MAKE SURE TO SET YOUR FOLDER (CD)

===================================================================================================================

Data\register_panel_full.dta: This is the full register data for 1907-1921 which is used to compute descriptive
	statistics for Table 1

year            int     %10.0g                Year
log_salary      float   %9.0g                 Log(Salary in $)
b               float   %9.0g                 Black civil servant
d_unit3         byte    %8.0g                 Paid per annum
d_unit4         byte    %8.0g                 Paid per day
d_unit6         byte    %8.0g                 Paid per month
log_rank        float   %9.0g                 Log(Job title rank)
dc              float   %9.0g                 Based in DC
tid             float   %9.0g                 Job title


Data\register_panel.dta:  This is the register data for 1907-1921, and 1897-1911 used for the main analysis

year            float   %10.0g                Year
salary          double  %10.0g                Salary in $
post            float   %9.0g                 1[Year>=1913]
log_salary      float   %9.0g                 Log(Salary in $)
age1910         float   %9.0g                 Age in 1910 (from Census)
elementary      float   %9.0g                 Elementary school education (from 1940 Census)
middle          float   %9.0g                 Middle school education (from 1940 Census)
highschool      float   %9.0g                 High school education (from 1940 Census)
college         float   %9.0g                 College school education (from 1940 Census)
education       float   %9.0g                 Years of education (from 1940 Census)
id              float   %9.0g                 Unique ID
dept_id         float   %9.0g                 Department ID
d_unit3         byte    %8.0g                 Paid per annum
d_unit4         byte    %8.0g                 Paid per day
d_unit6         byte    %8.0g                 Paid per month
around          float   %9.0g                 Years around presidential transition
b               float   %9.0g                 Black civil servant
d_a1_b          float   %9.0g                 
d_a2_b          float   %9.0g                 
d_a4_b          float   %9.0g                 
d_a5_b          float   %9.0g                 
d_a6_b          float   %9.0g                 
d_a7_b          float   %9.0g                 
d_a8_b          float   %9.0g                 
eid             float   %9.0g                 Transition-specific unique ID
w               float   %9.0g                 Transition sample (w=1: 1907-1921, w=0: 1897-1911)
p_b             float   %9.0g                 Post x Black
age             float   %9.0g                 Age
cem             float   %9.0g                 Matching weights
age_bins        float   %9.0g                 Age-bins
salary_pctile   float   %9.0g                 Salary percentile
d_dept1         byte    %8.0g                 dept==Agr
d_dept2         byte    %8.0g                 dept==C&L
d_dept3         byte    %8.0g                 dept==GPO
d_dept4         byte    %8.0g                 dept==GovtDC
d_dept5         byte    %8.0g                 dept==Int
d_dept6         byte    %8.0g                 dept==IsthCanalComn
d_dept7         byte    %8.0g                 dept==Jus
d_dept8         byte    %8.0g                 dept==NHDVS
d_dept9         byte    %8.0g                 dept==Navy
d_dept10        byte    %8.0g                 dept==PO
d_dept11        byte    %8.0g                 dept==State
d_dept12        byte    %8.0g                 dept==Treas
d_dept13        byte    %8.0g                 dept==War
female          float   %9.0g                 Female
dc              float   %9.0g                 Based in DC
tid             float   %9.0g                 Job title
log_rank        float   %9.0g                 Log(Job title rank)

===================================================================================================================
(*) NOTE: Tables and figures marked with (*) rely on restricted-access data from the full count census.
	The underlying datasets are constructed as described in the paper. The do files include the code used to 
	generate the tables and figures in the paper.
===================================================================================================================

